CampusAutoAwardSetting

EntityType | Dependent
Logical Entity Name | CampusAutoAwardSetting
Default Table Name | SyCampusAwardingConfig
Logical Only | NO
Owner | dbo
Definition |
Note |

CampusAutoAwardSetting Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
CampusId |  | INTEGER | NO |
AwardLetterAcceptanceFlag |  | CHAR(1) | NO |
PassiveAcceptanceDays |  | SMALLINT | NO |
AutoAwardPaymentPlanSettingId |  | INTEGER | YES |
DefaultAwardingLevelMethodology |  | CHAR(1) | NO |
AwardDisbursementOption |  | CHAR(1) | NO |
AwardDisbursementDays |  | SMALLINT | NO |
IsIsirImportTriggerEnabled |  | BIT | NO |
IsNsldsChangeTriggerEnabled |  | BIT | NO |
IsInstitutionalChargeChangeTriggerEnabled |  | BIT | NO |
IsEnrollmentStatusChangeTriggerEnabled |  | BIT | NO |
IsGradeLevelChangeTriggerEnabled |  | BIT | NO |
IsAcademicYearChangesTriggerEnabled |  | BIT | NO |
IsManualAwardsTriggerEnabled |  | BIT | NO |
IsDisbursementEligibilityFailTriggerEnabled |  | BIT | NO |
IsIsirCorrectionsTriggerEnabled |  | BIT | NO |
IsOriginatedLoanPackageLocked |  | BIT | NO |
IsAccessFromExternalSystemAllowed |  | BIT | NO |
IsNoelLevitzConfigurationEnabled |  | BIT | NO |
IsConnectedEnrollmentChangeTriggerEnabled |  | BIT | NO |
AwardLetterDeliveryFlag |  | TINYINT | NO |
EmailTaskTemplateId |  | INTEGER | YES |
WebAlertTaskTemplateId |  | INTEGER | YES |
CustomAwardLetterReportId |  | INTEGER | YES |
IsSystemInTestMode |  | BIT | NO |
TestModeAssignedToStaffId |  | INTEGER | YES |
TestModeAssignedToStaffGroupId |  | INTEGER | YES |
TestModeActivityTaskTemplateId |  | INTEGER | YES |
InitialPackagingStatusId |  | INTEGER | YES |
ReevaluationPackagingStatusId |  | INTEGER | YES |
QueueAwardLetter |  | CHAR(1) | NO |
QueuePackageStatus |  | XML | YES |
IsActive |  | BIT | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
LastModifiedUserId |  | INTEGER | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
ConnectedEnrollmentCOAType |  | CHAR(1) | NO |
ProrateDays |  | INTEGER | NO |

CampusAutoAwardSetting Keys

Key Name | Key Type | Keys
Nk_SyCampusAwardingConfig_UserId | Inversion Entry | LastModifiedUserId
PK_SyCampusAwardingConfig | PrimaryKey | CampusId

CampusAutoAwardSetting Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
AutoAwardPaymentPlanSetting | Non-Identifying | Zero or One to Zero or More |  |  |  | AutoAwardPaymentPlanSettingId | NO
Campus | Identifying | One To Zero or More |  |  |  | CampusId | NO
Staff | Non-Identifying | One To Zero or More |  |  |  | LastModifiedUserId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
SyCampusCensus_FAA | Non-Identifying | One To Zero or More |  |  |  |  | NO

CampusAutoAwardSetting Check Constraints

Check Constraint Name | CheckConstraint

CampusAutoAwardSetting Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.CampusAutoAwardSetting | NO |  |  |
Physical (Microsoft SQL Server) dbo.SyCampusAwardingConfig | NO |  |  |

CampusAutoAwardSetting Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | System

CampusAutoAwardSetting Data Movement Rules

Name | Type | Rule Text/Value